package cn.zb.mapper;

import cn.zb.entity.SysUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author
* @description 针对表【sys_user(用户信息表)】的数据库操作Mapper
* @createDate 2024-11-23 15:45:47
* @Entity cn.zb.entity.auth.SysUser
*/
public interface SysUserMapper extends BaseMapper<SysUser> {

    @Select("select menu_id from sys_role_menu where role_id = (select role_id from sys_user_role where user_id = (select user_id from sys_user where user_name=#{yhm}))")
    List<Integer> roleMenu(String username);

    List<SysUser> getUserByDept(String deptID);
}




